Crocon Technologies

Owner: croconamazon@gmail.com · Crocon · ← all brands

Active days

Sessions

113

Active hours

1.68

real mouse/keyboard time

Page views

Actions

Entities changed

Action mix

Bid

Budget

Status

Rule

Scheduler

Current automation state

Rules

2 / 6

active / total — 0 paused, 4 expired

Dayparting

1 / 1

active / total — 0 paused, 0 expired

Managers

Executives

Sellers

Vendors

Profile 3099208822337217 · amazon · europe

Top users on this brand

Email	Name	Role	Sessions	Active min
dolly.crocon@gmail.com	Dolly Negi	Manager	18	36.0
samajik.ams2@gmail.com	Akshat Gupta	Manager	60	33.1
admin@hectorai.live	Hector Admin	Admin	13	17.8
himanshi.crocon@gmail.com	Himanshi Chauhan	Manager	18	8.3
shalaka@hectorai.live	Shalaka M	Manager	3	5.5
mayank@hectorai.live	Mayank Makharia	Manager	1	0.2

Daily

Day	Users	Sessions	Active hours	Page views	Actions	Entities
2026-06-17	3	32	0.33	1	0	0
2026-06-18	5	18	0.62	1	10	10
2026-06-19	2	10	0.14	1	0	0
2026-06-20	1	1	0.01	0	0	0
2026-06-22	3	42	0.47	8	0	0
2026-06-23	1	3	0.03	0	0	0
2026-06-24	2	7	0.09	1	0	0

4 queries · scanned 24.15 MB · cost $0.000144 · 7.02s

Query 1 · 1 rows · 13.35 MB · $0.000080 · 2.14s

SELECT brand_group,
       ANY_VALUE(profile_owner_email) AS profile_owner_email,
       ANY_VALUE(company_name)        AS company_name,
       SUM(distinct_users)            AS user_day_rows,
       COUNT(DISTINCT day)            AS active_days,
       SUM(sessions)                  AS sessions,
       SUM(active_seconds)            AS active_seconds,
       SUM(page_views)                AS page_views,
       SUM(action_count)              AS action_count,
       SUM(entity_count)              AS entity_count,
       SUM(bid_actions)               AS bid_actions,
       SUM(budget_actions)            AS budget_actions,
       SUM(status_actions)            AS status_actions,
       SUM(rule_actions)              AS rule_actions,
       SUM(scheduler_actions)         AS scheduler_actions
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('Crocon Technologies')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group

Query 2 · 6 rows · 1.31 MB · $0.000008 · 1.41s

SELECT email,
       ANY_VALUE(full_name) AS full_name,
       ANY_VALUE(role)      AS role,
       SUM(sessions)        AS sessions,
       ROUND(SUM(active_seconds)/60.0, 1) AS active_min
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(brand_group) = LOWER('Crocon Technologies')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY email
ORDER BY active_min DESC
LIMIT 5000

Query 3 · 7 rows · 9.23 MB · $0.000055 · 2.17s

SELECT day,
       distinct_users,
       sessions,
       ROUND(active_hours, 2) AS active_hours,
       page_views, action_count, entity_count
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('Crocon Technologies')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY day

Query 4 · 5 rows · 273.0 KB · $0.000002 · 1.30s

SELECT *
FROM `amazoneast.customerio_data.vw_brand_state`
WHERE LOWER(brand_group) = LOWER('Crocon Technologies')
LIMIT 5